import pandas as pd
import warnings

warnings.filterwarnings("ignore")

path = '../成员/data/2 Japan Institute of International Affairs (JIIA)_merged.xlsx'
data = pd.read_excel(io=path)
text = data['member_otherinfo'][13]

lines = text.splitlines(True)  # 保留换行符
# 过滤空行
lines = [line for line in lines if line.strip()]
# 重新拼接成字符串
text = "".join(lines)
print(text)
